Dashboard 02 - Creating Year Over Year (YOY) Crimes Map 19


Next is to create Year Over Year (YOY) Crimes Map in the 2nd dashboard / page.


Step 1:  Create a Year Over Year (YOY) Crimes Map

In Power BI Desktop, click on the dashboard / page, RaleighPoliceIncidents-District

Visualizations

Click the Map  icon

Fields

Select the following:

A_KeyMeasures ->  .Total_Case_Numbers - Under Visualizations, drag & drop it in the Tooltips section.

A_KeyMeasures ->  .YOY_Total_Case_Numbers% - Under Visualizations, drag & drop it in the Size section.

A_KeyMeasures ->  Latitude - Under Visualizations, drag & drop it in the Latitude section.

A_KeyMeasures ->  Longitude - Under Visualizations, drag & drop it in the Longitude section.




Visualizations


Fields tab

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the fields as follows:

.Total_Case_Numbers = Total Police Incidents

.YOY_Total_Case_Numbers= YOY Police Incidents

Latitude = Latitude

Longitude = Longitude




Format tab

Similar to the previously created map , set up the format as follows:

Under Format ->  General: X Position = 764 , Y Position = 189 , Width = 635 , Height = 392

Under Format ->  Data Colors ->  click fx for Expression ->  Format by = Color Scale, Based on Field = .YOY_Total_Case_Numbers% , Minimum ->  Custom Color = 008000 and Value = 0.000001 , Center ->  Custom Color = F5FF00 and Value = 0.25 , Maximum ->  Custom Color = FF0000 and Value = 1

Under Format ->  Category ->  Set it to OFF

Under Format ->  Bubbles ->  Size = 10

Under Format -> Map Controls ->  Auto Zoom = ON , Zoom Buttons = ON

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666





Step 2:  Add Legend image

Add a legend image to the map.

Import the image by clicking on Insert ->  Image  ->  browse to the extracted folder ->  template and select the image YOYCrimeRateLegend_2020-12-16_115716.jpg

Format tab

Under Format ->  General: X Position = 764 , Y Position = 144 , Width = 635 , Height = 45

Under Format -> Set all other options to OFF



Step 3 - Add filter(s)


Filters

On the map, If there is any location outside the Raleigh area, right-click on it and select Exclude.



When finished, save project.



For tips on how to create maps in Power BI Desktop:


Creating Shape Map visualizations in Power BI Desktop